﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Region.aspx.vb" Inherits="Lens.Region" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
    .style2
    {
        font-size: x-large;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
    <br />
&nbsp;<strong><span class="style2">Sort by Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:Button ID="Button1" runat="server" Text="View Your Profile" />
        </strong></p>
<p>
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
        DataSourceID="listtagRegSqlDataSource1">
        <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="TagRegion" 
                DataNavigateUrlFormatString="Region.aspx?TagRegion={0}" 
                DataTextField="TagRegion" HeaderText="Select Region">
            <HeaderStyle BackColor="Black" ForeColor="White" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:HyperLinkField>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="listtagRegSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
        SelectCommand="SELECT [TagRegion] FROM [TagRegion] ORDER BY [TagRegion]">
    </asp:SqlDataSource>
</p>
<p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="tagRegSqlDataSource1" Width="916px">
        <Columns>
            <asp:BoundField DataField="PictureTitle" HeaderText="PhotoTitle" 
                SortExpression="PictureTitle">
            <HeaderStyle BackColor="Black" ForeColor="White" HorizontalAlign="Center" 
                VerticalAlign="Middle" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="Location" HeaderText="Location" 
                SortExpression="Location">
            <HeaderStyle BackColor="Black" ForeColor="White" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="NameOfUploader" HeaderText="Uploader" 
                SortExpression="NameOfUploader">
            <HeaderStyle BackColor="Black" ForeColor="White" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="Description" HeaderText="Description" 
                SortExpression="Description">
            <HeaderStyle BackColor="Black" ForeColor="White" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:ImageField DataImageUrlField="Picture" HeaderText="Photo">
                <ControlStyle CssClass="uploadedPicture" />
                <HeaderStyle BackColor="Black" ForeColor="White" />
                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:ImageField>
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="detail.aspx?ID={0}" HeaderText="Detail" 
                Text="Detail">
            <HeaderStyle BackColor="Black" ForeColor="White" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:HyperLinkField>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="tagRegSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:lensPicConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:lensPicConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT DISTINCT [TagRegion], [ID], [PictureTitle], [Location], [NameOfUploader], [Picture], [Description] FROM [TagRegionView] WHERE ([TagRegion] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="TagRegion" QueryStringField="TagRegion" 
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
</asp:Content>
